AIREA conversational analytics evaluation reference pack
Version 1.0 | November 3, 2026

Use with the evaluation guide and workbook. Start with orders.csv and dispatches.csv.
The expected files are reference answers for this worked case. Run the questions in your
proposed pilot and compare its observations; no tool results have been filled in for you.

CASE RULES
One row per order. Each order has one item and a fixed required quantity.
Select original promises from October 1 through October 31, 2026.
Review records through November 2, 2026, inclusive. All dates close at the end of the
local calendar day in America/Toronto. The pack contains date-level, not hourly, data.
An eligible order is late unless its full quantity was dispatched by its original promise.
Keep open eligible orders in the denominator. A revised promise does not replace the original.
Exclude a fully cancelled order only when cancelled on/before its original promise and by cutoff.
A missing original promise has unresolved eligibility. Show it separately; do not substitute
the revised date. The supplied case includes complete dispatch history for its known orders.

EVENT HANDLING
D002 appears twice with identical fields. Use it once. If two records for one event ID conflict,
resolve them instead of selecting one without evidence. D099 links to X99, which is absent from
the supplied orders. Keep that unmatched event separate and obtain the missing reference.

REFERENCE ANSWER
East: 5 eligible orders, 3 late (60%), including 1 still open.
West: 5 eligible orders, 2 late (40%), including 1 still open.
Known October cohort: 10 eligible, 5 late (50%), including 2 still open.
Other supplied orders: 1 cancelled, 2 outside the period, 1 with a missing original promise.
East Standard: 3 eligible, 1 late (33.3%). East Priority: 2 eligible, 2 late (100%).
Percentages in CSVs are decimal ratios. Compute totals from counts, not averaged percentages.
Resolve missing eligibility and unmatched events before treating this as a complete business result.

FILES
orders.csv: order ID, warehouse, order type, original/revised promises, required units and full cancellation.
dispatches.csv: event ID, order ID, dispatch date and units. One dispatch can be partial.
expected-warehouse-results.csv: warehouse and combined reference totals.
expected-east-follow-up.csv: East warehouse split by order type with the original scope retained.
expected-order-results.csv: order-level classification and quantities used by the reference.

For your business question, complete the workbook's Question card and establish a separate
checked comparison using your own approved data. The fixed example formulas cover only this pack.
Bring one question card to an AIREA pilot discussion: https://www.getairea.com/request-demo/
